Excel Shortcut Keys Quiz – 30 MCQ Questions with Answers
Microsoft Excel is widely used for data entry, calculations, reports, accounting, data analysis, and many other office tasks. Knowing the right Excel shortcut keys can help you perform common tasks more quickly and efficiently.
In this quiz, you will find questions about shortcuts for copying, pasting, saving, formatting, navigation, formulas, worksheets, filtering, tables, and other common Excel operations.
- Total Questions: 30
- Type: Multiple Choice Questions (MCQ)
- Level: Beginner to Intermediate
- Topic: MS Excel Shortcut Keys
- Answers: Given below each question
Excel Shortcut Keys Quiz – 30 MCQs
Which shortcut key is used to copy selected cells in Excel?
Ctrl + C copies the selected cell, range, or other selected content.
Which shortcut is used to paste copied content in Excel?
Ctrl + V pastes copied or cut content into the selected location.
Which shortcut is used to cut selected data in Excel?
Ctrl + X cuts the selected content so it can be pasted elsewhere.
Which shortcut is used to undo the last action in Excel?
Ctrl + Z reverses or undoes the most recent action when undo is available.
Which shortcut is used to save an Excel workbook?
Ctrl + S saves the current workbook.
Which shortcut opens the Find option in Excel?
Ctrl + F opens the Find feature so you can search for content in the worksheet.
Which shortcut opens Find and Replace in Excel?
Ctrl + H opens the Find and Replace dialog.
Which shortcut makes selected text or cell content bold?
Ctrl + B applies or removes bold formatting.
Which shortcut applies italic formatting in Excel?
Ctrl + I applies or removes italic formatting.
Which shortcut applies or removes underline formatting?
Ctrl + U applies or removes underline formatting.
Which shortcut opens the Format Cells dialog box?
Ctrl + 1 opens the Format Cells dialog box.
Which shortcut inserts the current date in Excel?
Ctrl + semicolon inserts the current date.
Which shortcut inserts the current time in Excel?
Ctrl + Shift + semicolon inserts the current time.
Which key is used to edit the active cell?
F2 allows you to edit the contents of the active cell.
Which shortcut is commonly used to insert AutoSum in Excel?
Alt + = activates AutoSum and can insert a SUM formula based on the surrounding data.
Which shortcut creates a table from selected data in Excel?
Ctrl + T opens the Create Table dialog for the selected data range.
Which shortcut turns filters on or off for a data range?
Ctrl + Shift + L toggles AutoFilter for a data range.
Which shortcut selects the entire row containing the active cell?
Shift + Space selects the entire row containing the active cell.
Which shortcut selects the entire column containing the active cell?
Ctrl + Space selects the entire column containing the active cell.
Which shortcut moves to the beginning of a worksheet?
Ctrl + Home moves to the beginning of the worksheet, normally cell A1.
Which shortcut moves to the last used cell of a worksheet?
Ctrl + End moves to the last used cell in the worksheet.
What does Ctrl + Page Down do in Excel?
Ctrl + Page Down moves to the next worksheet tab.
What does Ctrl + Page Up do in Excel?
Ctrl + Page Up moves to the previous worksheet tab.
Which shortcut creates a new Excel workbook?
Ctrl + N creates a new workbook.
Which shortcut opens an existing Excel workbook?
Ctrl + O opens an existing workbook.
Which shortcut closes the current workbook window?
Ctrl + W closes the current workbook window.
Which shortcut fills a selected range downward using the top cell?
Ctrl + D fills the selected range downward using the contents of the top cell.
Which shortcut fills a selected range to the right?
Ctrl + R fills the selected range to the right using the leftmost cell.
Which shortcut opens the Print options in Excel?
Ctrl + P opens the Print options.
Which shortcut starts a new line within the same Excel cell while editing?
Alt + Enter inserts a line break within the same cell while you are editing it.
Excel Shortcut Keys – Quick Revision Table
| Shortcut | Function |
|---|---|
| Ctrl + C | Copy |
| Ctrl + V | Paste |
| Ctrl + X | Cut |
| Ctrl + Z | Undo |
| Ctrl + S | Save |
| Ctrl + F | Find |
| Ctrl + H | Find and Replace |
| Ctrl + B | Bold |
| Ctrl + 1 | Format Cells |
| F2 | Edit Active Cell |
| Alt + = | AutoSum |
| Ctrl + T | Create Table |
| Ctrl + Shift + L | Toggle Filter |
| Ctrl + Home | Go to Beginning |
| Ctrl + End | Go to Last Used Cell |
Don't try to memorize all Excel shortcut keys at once. Start with the most common shortcuts such as Ctrl + C, Ctrl + V, Ctrl + X, Ctrl + Z, Ctrl + S, Ctrl + F and gradually learn more. Regular practice is the easiest way to remember keyboard shortcuts.
Why Are Excel Shortcut Keys Important?
Learning Excel keyboard shortcuts can make everyday spreadsheet work more efficient. They are especially useful for students, teachers, accountants, data entry operators, office employees, and anyone who works regularly with Microsoft Excel.
- Save time on repetitive tasks.
- Reduce dependence on the mouse.
- Navigate large worksheets faster.
- Format cells quickly.
- Work with formulas more efficiently.
- Manage tables and data more easily.
Frequently Asked Questions
What is the shortcut key for Copy in Excel?
Ctrl + C is used to copy selected cells or content in Excel.
What is the shortcut key for Paste in Excel?
Ctrl + V is used to paste copied or cut content.
What is the shortcut key for AutoSum?
Alt + = is commonly used to activate AutoSum in Excel.
What is the shortcut key to edit a cell?
Press F2 to edit the active cell.
What is the shortcut key to create a table in Excel?
Select your data and press Ctrl + T to open the Create Table dialog.
Are Excel shortcut keys useful for beginners?
Yes. Beginners can start with a small number of frequently used shortcuts and gradually learn more. This can make common Excel tasks easier and faster.
Conclusion
This Excel Shortcut Keys Quiz is designed to help beginners test their knowledge of commonly used Microsoft Excel keyboard shortcuts. From basic commands such as Copy, Paste, Save, and Undo to shortcuts for formulas, tables, filters, worksheets, and navigation, these keyboard shortcuts can help you work more efficiently in Excel.
If you found this quiz useful, practice the questions again and try to use these shortcuts while working on real Excel worksheets. With regular practice, remembering MS Excel shortcut keys becomes much easier.
Comments
Post a Comment